package table

// 初始化SQL语句

const SQL_TABLE = `

	CREATE TABLE IF NOT EXISTS "REDIS_SETTING" (
		   "ID" INTEGER PRIMARY KEY AUTOINCREMENT,
		   "NAME" VARCHAR(256) NOT NULL,
		   "Content" VARCHAR(512) NULL,
		   "Status" INTEGER NOT NULL,
		   "Create_Time" TIMESTAMP DEFAULT (datetime('now', 'localtime'))
	);
	
	CREATE TABLE IF NOT EXISTS "OpLog" (
	   "Id" INTEGER PRIMARY KEY AUTOINCREMENT,
	   "Record_Id" INTEGER NOT NULL,
	   "Record_Name" VARCHAR(256) NULL,
	   "Content" VARCHAR(512) NULL,
	   "Status" INTEGER NOT NULL,
	   "Create_Time" TIMESTAMP DEFAULT (datetime('now', 'localtime'))
	);

   `

//type RedisSetting struct {
//	Id         int
//	Name       string
//	Host       string
//	Port       int
//	Database   int
//	Username       string
//	Password   string
//	DelFlag    int
//	CreateTime time.Time
//}
